SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003877s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203574 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203574 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009981,245483,866489,315261,996424,928225,266230,241284,85926,654856,603037,672918,93767,657784,435085,639016,439850,200862,617276,212451,524501,90413,1005304,108946,739799,596863,160626,27299,262689,662224,654394,134592,162639,406966,59792,70857,872236,753360,993091,562045,869051,715584,951259,675531,277419,156503,600427,506657,928562,582712,779078,895379,986156,621173,761711,1001918,1030603,929016,123565,880012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203574 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203574 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001303s ]