SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563841 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563841 [ RunTime:0.001502s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (83818,812033,791324,1032165,700693,169649,781144,38699,504029,711843,745163,893536,614664,341914,232550,256965,189212,148684,1004378,178509,676360,477156,791441,236072,1005347,192965,341993,837879,82082,369635,670120,450679,155642,871238,244029,745348,442231,531729,188646,139569,555628,542350,340299,926509,757363,521860,399436,774455,437562,712966,545780,195597,87731,612658,884189,154068,939075,891124,889990,533623) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]