SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417751 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417751 [ RunTime:0.001560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859462,159335,687823,1048302,832472,138023,471475,865416,75263,77880,878713,121674,917559,201942,446171,532971,760392,453589,1003114,900665,207417,424081,516666,204100,761858,399002,654402,444380,504481,200333,454372,597117,559751,989511,937146,312181,922110,331179,665767,559058,996258,968179,641519,927704,983660,649062,736392,446289,770790,145981,329297,390490,994902,994340,979088,179190,628495,409448,757365,673298) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]