SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984228 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984228 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020815,869100,271380,209385,575773,508686,547199,685959,316432,388619,566580,1003118,399361,954880,798953,471098,961823,862504,16518,172731,345965,865542,325030,1012578,641060,623418,128926,47625,290076,485993,900136,74221,39605,236610,790070,939420,637119,889381,514301,830328,558096,970936,617097,141489,408240,714728,585301,1045643,341426,907835,272962,52773,990811,975998,159565,1031780,697475,50725,924752,526546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]