SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002752s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 948596 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 948596 [ RunTime:0.002434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (97910,1000444,870093,750845,331047,1041875,625674,570279,464722,155859,352988,150544,356030,436635,24670,847547,754192,571309,774150,268021,1037879,406826,980914,222701,386894,534366,755896,912204,656365,522127,30521,903969,933250,495957,153452,291410,17899,321466,514666,713487,844554,249464,343384,966156,441862,162508,689473,100647,244563,1016787,137075,158169,9321,561309,1046374,9028,664240,808857,173367,301888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 948596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 948596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]