SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 119368 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 119368 [ RunTime:0.002215s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (51192,543936,667890,625959,532040,61590,169467,665929,397635,636703,689899,7974,840133,202645,338470,891471,101104,560685,406136,343574,298873,903640,368129,144521,552163,573535,848708,466849,297575,242681,173649,1012399,661783,980088,699011,618974,26420,117207,997696,193047,785039,864786,458491,336484,261354,786090,298653,304885,82355,599490,300064,381119,940459,590303,440666,532862,426807,884410,697240,280505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 119368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 119368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000362s ]