SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338581 LIMIT 1 [ RunTime:0.001739s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338581 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115029,357680,15182,353108,848660,351562,248808,108494,49831,705249,155328,331506,415067,700710,261230,559223,123121,723625,200236,914061,1008995,117770,879830,253670,123089,763075,915972,346901,858964,143964,667860,360564,433411,492202,101412,993534,854255,381287,743659,432880,537842,763524,500208,877992,114977,1010958,281378,511157,654898,805125,435894,1039285,652187,194906,42494,556394,732556,92886,1030545,706739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000632s ]