SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598910 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598910 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76552,456148,466542,621181,158915,51412,473178,498672,739084,114805,991607,579142,394298,350451,316078,687629,658738,990563,294282,313926,22568,130448,137773,225986,516407,573750,648146,880657,48783,692276,285424,875072,243756,268880,834420,504157,543748,555077,977176,686846,71109,248595,738153,767494,431324,541020,35938,857361,611240,533101,528595,275706,764569,208776,50757,97458,487859,506506,290493,532263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000434s ]