SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 722017 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 722017 [ RunTime:0.004222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (531171,606614,118828,758440,722757,716021,528642,431514,184628,978257,879287,355410,318253,492667,112611,192790,394482,21504,664534,616324,490505,52660,1027064,432688,904678,219119,453491,451327,269136,11637,312901,62581,943118,779253,783315,685355,448205,992665,153432,205154,665140,642486,649073,562399,672624,959044,914367,449264,796429,671973,728179,943588,576578,868184,202671,21958,976013,382383,454501,315833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 722017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 722017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]