SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003528s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575073 LIMIT 1 [ RunTime:0.000836s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575073 [ RunTime:0.004751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410508,887642,188886,420170,696829,622632,155002,75856,928284,101908,754173,148224,334389,1020409,552970,771134,96545,1002740,539600,758396,543095,891774,364012,151468,381673,41467,289595,222853,953134,209475,377393,1036266,20529,581941,656392,899555,1046564,212004,443300,1000722,691277,445023,588697,28599,211076,679807,563322,13606,422858,731669,742818,911527,709012,589474,756873,97001,1046511,981938,128492,750771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003858s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575073 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575073 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]