SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520244 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520244 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261258,221302,695002,828815,1010076,4783,61178,353469,354012,708751,200808,655065,478485,722121,536967,604413,307538,166950,327693,518001,314310,181358,52945,817123,864217,279858,901052,668450,801654,832371,678001,853518,441892,630984,448293,619017,524734,362253,820596,776714,940214,567734,147832,680573,648974,120593,36435,895226,706179,26433,839180,103796,572563,415162,303496,587505,439895,800485,601365,95709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520244 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520244 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001066s ]