SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014221 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014221 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (556289,363067,446268,621584,830806,110974,1028343,413615,946494,657859,418972,387844,425879,261385,127102,587704,335662,876221,96822,113650,613931,576204,1013106,342873,702452,45203,435642,978933,843766,593131,545933,882612,188922,777483,467414,370879,651137,592622,723316,651739,202334,526902,414921,646291,543999,560678,66711,871668,733916,46269,855541,631419,238249,890553,845609,247686,1047023,543242,24441,360794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000961s ]