SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467926 LIMIT 1 [ RunTime:0.001161s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467926 [ RunTime:0.002748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229770,707726,805427,17552,454240,922354,891127,218157,547115,515984,903914,450446,974276,997159,156225,653223,422871,1002362,681887,540653,193914,1000687,462782,321297,722860,355528,334712,236339,689326,986536,547043,1044001,492699,486673,223803,206523,751224,425617,227776,420137,774537,761607,747233,507131,1025786,703252,196304,176669,138805,527095,694637,961293,271739,401550,275961,354749,848416,855908,731897,811446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001821s ]