SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019744 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019744 [ RunTime:0.002273s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777597,160207,524418,875195,281340,746323,555541,834244,896090,70050,72870,545527,602390,290471,305371,646283,659151,539551,407633,591551,426182,290099,752595,930858,919205,1018621,764131,583516,1040980,701331,582233,128228,586092,570148,643841,910150,895608,348104,673547,1030686,153206,232118,741413,98806,47580,761730,266140,576129,1036627,200479,1045035,617000,392478,977831,290529,32243,817972,791104,731345,801033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019744 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019744 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002686s ]