SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596590 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596590 [ RunTime:0.001786s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484095,251048,665695,933970,45460,262034,114709,137747,813686,911223,259981,750801,479783,243074,191581,967679,882851,1020875,948010,501811,264330,340947,723278,515961,437965,965781,835047,282254,406312,13538,750193,632403,195914,967135,766460,59046,42886,922590,1008885,1019929,574943,930717,329491,131389,676157,663528,576663,796987,207711,604351,1039172,724149,806595,448655,169214,353583,750608,411075,485285,746467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]