SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505283 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505283 [ RunTime:0.003233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519062,705225,586566,1031786,263267,57770,451745,784806,520417,752117,233468,305084,587682,339269,509715,79324,444570,660984,857956,494588,5538,270935,1048480,482085,540767,581395,713799,21614,130753,887918,472214,698833,188309,13496,866291,562741,986188,558272,599281,1045097,828520,41515,908051,127748,345258,294309,686881,932293,157906,339216,132857,585345,365928,191046,736286,922563,74388,418080,585657,227352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]