SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 449103 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 449103 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (620530,805103,498227,776155,463240,395436,816190,894768,532111,764453,491903,50606,725754,396640,295408,315781,430978,436417,487741,969713,21704,160874,463040,963972,538049,678778,349454,641465,383973,203197,579272,94693,919919,584448,498349,127448,930122,915361,251805,662845,143976,481501,9096,727630,377790,344354,560866,600773,702457,9067,310066,500820,443070,612803,735634,885646,196685,957757,679730,542691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 449103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 449103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]