SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316908 LIMIT 1 [ RunTime:0.001032s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316908 [ RunTime:0.004023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (18375,490811,79926,684180,916196,269945,424411,179767,60798,401410,1016810,288110,1011492,797317,968007,853983,412597,75565,675072,108015,896835,1040608,706599,166121,807291,410733,601621,977802,607764,1018421,231280,88106,257041,295152,894329,998783,291945,802095,993208,286226,171508,742857,751506,532546,924430,847938,582790,113847,277548,381216,588223,1017974,907695,808230,916674,367896,145150,50382,803157,180240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000571s ]