SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424118 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424118 [ RunTime:0.003169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044898,100721,801736,428361,282823,654256,644588,166716,127366,896779,651609,327586,388898,766499,582459,525310,393996,132370,151262,230029,843553,72125,967871,418164,798707,746396,117431,415857,907581,515133,470507,178357,540247,373652,467394,316396,424251,254471,165873,521481,155453,768893,808193,412747,719874,807718,477848,264300,757580,382959,591275,31702,1015531,878775,451312,651435,969014,1033628,72243,383174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001479s ]