SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 637503 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 637503 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (312963,524302,690805,788878,489581,24677,367424,1005977,792032,26934,228760,429187,1016096,193180,476045,1026842,396173,1023349,994297,378690,119318,28808,897480,692141,430636,132796,1012879,800010,40607,921930,361294,428284,809246,495444,916918,487911,330917,816739,683964,45326,44651,34003,145961,327425,444534,328698,506028,638663,755839,166320,709490,976840,769734,286053,1040437,192130,18004,449705,323762,529956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 637503 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 637503 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]