SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 66411 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 66411 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470260,784449,722502,1017049,438828,112542,686783,252243,857635,888849,40602,452405,177453,945077,928104,165960,78944,442882,965168,205140,397170,442382,995534,284673,49747,816448,992038,578675,469858,730959,48883,832699,210932,800499,979460,836120,123841,238276,879788,517658,459164,1037821,746973,781895,354221,502312,869011,100303,560120,879643,975978,1045338,82733,207158,675818,384803,829709,43894,301627,611201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 66411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 66411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]