SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286100 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286100 [ RunTime:0.002355s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310995,181299,91806,417796,194930,450398,278394,939283,91495,1007319,1044541,969294,902779,465996,71381,1016076,365000,951212,386026,925809,49823,85955,810890,1046926,176672,414252,274536,840507,372080,214396,929817,55372,388610,679343,927337,691063,998614,497302,428925,492176,805932,343313,373035,226736,610082,893341,164851,21890,420762,912185,284760,1021153,247905,743576,406779,446721,49473,52260,424930,239970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000504s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000871s ]