SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 562108 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 562108 [ RunTime:0.001968s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56344,514002,234391,6207,689338,850817,575480,26669,769526,172356,204724,917448,623633,173442,140399,329573,819718,761573,211220,899937,44780,36268,500405,983856,270595,905593,500712,682638,1019444,993936,623088,869581,499979,595,221543,805973,101166,757266,485675,352426,1034107,304224,409293,542850,313047,809694,828417,929772,192262,969169,464293,184792,956952,704606,192342,212548,976547,444756,723889,65972) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 562108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 562108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000771s ]