SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393613 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393613 [ RunTime:0.002621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (335338,250003,264030,102376,909391,544425,955937,938263,739016,108637,352598,697806,316358,652980,940326,893529,600185,836681,803397,16879,444410,45420,845735,467202,1030952,133943,250932,913116,994788,635616,358046,189630,910635,910855,207236,949150,374532,694774,239993,97829,351937,1013825,419492,900809,339169,565392,313852,362018,468176,520097,290796,16198,404323,467676,393317,628234,850320,348850,907256,293905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003538s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003993s ]