SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009712 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009712 [ RunTime:0.001650s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701930,396419,934022,441252,505601,40003,268884,394423,955997,1014083,1048224,781452,730708,273819,311587,752679,313500,941377,1023172,903385,421421,466318,67016,776739,703204,601077,79500,853756,1022296,257991,578362,979910,47040,757367,701169,643018,780928,912831,883770,263255,588233,821072,182792,58010,643876,274844,893578,676259,700590,986413,970250,619391,722232,572240,16401,411416,136290,535362,26515,652775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]