SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564891 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564891 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55111,555270,692322,754991,987334,193758,540570,151754,846975,814086,368431,746009,498883,1047022,439364,518510,1022784,836516,672438,251892,561587,604121,910859,856333,56818,989996,434372,141812,207135,72403,428976,756766,752156,754291,3984,897217,635027,401496,1029724,948989,87505,226964,585974,949094,971116,1021308,692693,1005831,204912,157996,287022,361269,739757,275809,997275,677946,149068,647247,162666,40795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]