SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281026 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281026 [ RunTime:0.003876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (642727,405058,426140,521427,310507,398305,427887,1014295,326116,524829,539882,413819,665417,142580,669880,185068,20541,106817,143031,880594,811724,749366,143830,493907,499967,700350,257527,752988,870482,830989,199229,832194,746626,728627,841129,560637,330759,33137,673759,579600,1028010,611013,877213,703570,342464,836946,718663,1004747,985964,169865,463457,251548,626832,610746,518658,826453,137709,987777,693744,1007708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000416s ]