SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004891 LIMIT 1 [ RunTime:0.002296s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004891 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153185,709525,397218,354309,256688,382669,350985,655201,215037,1036926,504831,190139,597348,144344,323930,45474,662263,167116,854144,259122,62447,896492,634663,515742,509559,507892,397103,78289,550208,189944,286242,626256,475990,619595,879200,185426,567609,808409,495437,740498,703138,63573,826040,450575,384930,269654,344479,612970,20642,705080,353065,234982,1000646,779811,882014,243817,71089,997541,170279,529676) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]