SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493806 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493806 [ RunTime:0.001852s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591952,853069,360648,807617,154563,98239,331971,105767,258150,529459,147024,305040,79048,1008954,536282,86649,892991,731307,53319,314788,681277,39144,833388,746490,670281,984407,895205,6270,198898,984353,695456,436946,932486,362112,676963,726468,543896,17150,520459,436789,8222,533419,988021,956258,512274,637454,666412,266419,514968,1025039,913310,165073,569441,574525,968822,338907,561948,629928,421164,514499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]