SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41019 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41019 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511117,872642,621249,679895,145677,45399,716566,802573,451831,204497,203169,943483,696544,731977,781752,138107,55917,183581,500345,258463,533152,530635,1029988,784737,655649,290956,49737,266213,486656,623100,1013612,1009600,900872,82945,620726,450232,390283,457710,317783,422747,552967,208764,239359,541800,948180,92350,934016,43286,651538,999826,530626,940000,216451,641899,237292,31972,681966,603464,433777,196342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002561s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001132s ]