SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 344752 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 344752 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (343942,40341,533443,1026292,840981,609095,388117,324358,922898,920315,365597,337439,2805,953205,441660,434072,350728,203221,518527,47021,144549,988668,912240,416310,437903,355871,198024,324513,632854,1032001,902237,699264,308987,248084,482580,236072,287915,552306,230575,41432,399443,922858,293661,53125,309350,231000,530511,913346,45224,693296,598888,225146,441604,1030201,69901,792286,434228,173425,632929,895740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 344752 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 344752 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]