SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407309 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407309 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221173,174077,264455,917547,1047093,793408,628523,249628,116894,364438,247360,350083,977923,809873,576973,90435,398398,390929,614809,31038,826877,112535,1038996,706608,975382,780398,894060,269707,330386,1044093,251296,565504,85377,52754,260422,88276,45139,79768,867329,644503,840279,251966,983636,343191,1012001,543918,181277,835738,7530,824891,662385,520933,941812,826682,443266,874197,717361,281849,12215,767405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]