SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026370 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026370 [ RunTime:0.003808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (293717,407779,782064,397481,313143,572678,310922,1025710,481089,967180,551816,419075,228690,243340,1038025,595763,1044803,74252,165533,57857,35475,282496,219820,703281,106562,938395,295882,986106,41553,221364,363015,187803,610576,15009,391790,563952,541924,887799,149102,648852,399591,168954,423070,532074,1041556,363152,554557,878558,159735,116999,361045,747769,919075,672117,574680,966367,507095,40215,39753,969987) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026370 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026370 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]