SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005436 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005436 [ RunTime:0.004459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199333,438625,821380,356705,28147,207103,688650,895546,161512,137028,334840,384135,389258,995766,890273,44019,708276,852810,348838,655756,923026,202374,325121,885404,986208,826077,306530,464550,559141,811257,728443,450957,1003525,943846,519978,763276,875755,682696,151073,8966,780788,629330,325735,637640,999475,364691,823213,224316,338287,130026,306599,128262,989583,229750,822076,196396,1010872,592559,106365,294370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002717s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005436 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000599s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005436 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]