SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014439 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014439 [ RunTime:0.004362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (761330,73321,983158,197718,400041,556251,702035,552783,792393,277558,158528,229526,1043934,416975,398836,833874,730866,25595,61209,266464,909481,710540,721357,192363,324711,140231,73874,480785,809419,234262,860028,95943,863233,249152,313200,280497,41460,580527,452492,840263,363959,821662,208886,98959,783978,904808,895085,83963,391566,241526,28836,691965,848933,40288,256679,340103,899010,609880,526336,434339) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014439 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014439 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]