SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464413 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464413 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (46825,399878,393007,202412,255813,841789,133061,152622,271339,705477,89358,742992,806996,856720,931198,197034,842992,136293,1028368,482497,294800,980552,222136,611478,590536,435607,447650,920092,130056,14856,288274,580107,372644,434334,296572,650849,507391,809664,724867,399725,1010193,1043477,616791,432998,778194,158989,52862,49536,902937,297377,152262,684429,515734,132641,198570,28144,885185,786272,866772,231190) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001023s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]