SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264335 LIMIT 1 [ RunTime:0.000971s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264335 [ RunTime:0.003802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711982,779305,891045,117248,209579,204807,600943,594610,587377,241895,135122,156563,1002957,261355,74310,585228,444468,184065,100311,543836,278141,554001,211148,271396,689317,563044,20576,1005107,487073,891523,274711,748205,621439,766013,327890,21710,177380,1045718,1045650,111081,855696,965587,484487,727532,477195,769531,303836,629972,992482,773443,588844,596375,692943,823661,212653,387547,1044164,1011621,1007066,173546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000910s ]