SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262119 LIMIT 1 [ RunTime:0.004371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262119 [ RunTime:0.001055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008496,116517,521544,580591,362195,211988,237424,903751,251904,1023120,309536,160531,323749,744243,441591,10648,59551,40966,789430,620011,317453,370350,614093,89663,483887,845884,622320,238974,192138,229875,727823,847393,349218,491430,405738,62490,391413,307760,5498,1017963,338222,360587,1014689,676655,1018133,466633,477969,61794,974019,444328,543787,987345,210525,96193,626591,915988,217563,547094,833282,49528) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262119 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262119 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]