SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002874s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266584 LIMIT 1 [ RunTime:0.002502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266584 [ RunTime:0.004175s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (987250,404587,697367,770591,649888,738028,743273,567703,670964,341556,421437,1042865,423980,797960,97168,712522,699699,166483,1014264,918323,602369,707660,700389,960179,819025,811087,638294,636663,568550,353905,640100,730340,568287,323159,941721,132926,343591,78371,403651,926143,989747,720390,592259,1037247,379570,110303,338701,826289,1031958,731237,399145,268148,330608,871340,115946,911349,833404,102570,699375,165411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002849s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]