SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001898s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479087 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479087 [ RunTime:0.001515s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570519,160119,231221,187943,824860,698937,693806,1046710,667414,455147,74615,507100,658779,321691,111988,1039652,644018,373907,1007297,519486,781482,339476,1045544,965430,68919,808499,414852,398457,898751,164328,533190,581786,889032,145046,78042,455064,527675,62848,559624,106668,383307,108701,765218,75411,102864,543488,643029,672576,82963,345585,185194,586173,878483,322946,400859,286905,1045880,539776,99738,747363) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000702s ]