SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 347580 LIMIT 1 [ RunTime:0.001067s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 347580 [ RunTime:0.002287s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304524,529745,1033344,1008363,505347,956703,229430,601667,568246,424859,83337,192027,591124,426993,672909,583051,547849,340866,393068,457361,463030,1005628,824274,736960,585028,696040,848989,140046,994025,115917,393170,695306,1047004,323002,363523,745387,314213,931916,91858,62647,191577,901168,690868,567795,1002887,989811,747286,843964,925947,260838,74090,172400,961632,1035991,995087,324449,909,575585,278954,248067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 347580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 347580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001682s ]