SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001552s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003410 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003410 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (907149,105089,219009,266467,221931,866939,923595,267854,1013475,130578,68802,331618,245455,732841,216549,959475,292577,173402,573939,803554,574884,393667,746143,224948,963973,725043,775742,648028,594114,678429,305323,83882,253804,68003,509966,67844,568523,824383,644646,175929,847241,939325,639391,460564,423616,353586,351729,1041883,871463,564781,27901,148083,137063,588017,515747,858235,274750,155169,273567,112292) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]