SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418771 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418771 [ RunTime:0.004174s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31969,621470,975420,863327,67253,698009,976012,266806,50614,488447,477483,506500,19723,526716,814997,731864,763098,964558,129731,221617,241161,925129,716324,984433,860827,740619,180045,1015227,10226,384965,527197,511715,555192,1003679,33304,581383,625973,565892,573667,71055,633254,313558,381706,22055,45485,790949,295306,429667,1019172,35180,397418,738340,999413,393471,159343,71194,39381,253370,61028,1016353) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]