SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141811 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141811 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (570812,629048,346484,8019,1000273,181314,41589,81119,1045273,844509,236561,306134,350923,905979,97445,120213,722828,567898,150859,143242,286667,425358,866542,408955,430252,63558,417193,944488,434290,563143,1005349,311851,261120,905995,288453,985204,28291,996687,141256,768483,803233,269810,479153,944368,372856,242567,649331,727120,954604,483278,587454,898242,1032709,289965,615668,219754,77738,715214,773274,870656) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]