SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404494 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404494 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122132,785371,968254,216442,166765,186166,876447,101496,468539,417508,912237,255166,659763,1031395,140358,667788,790999,846616,280481,177765,222573,712190,52219,373717,670981,208165,1007412,582933,592573,136776,713850,264954,234408,74072,246439,528041,440740,63406,896482,753477,507706,25647,994888,832704,1031484,246287,193171,728846,723804,1004414,846380,1022831,526658,632521,364826,445586,950241,918111,42134,597059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001666s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003623s ]