SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575516 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575516 [ RunTime:0.003093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393088,401047,153188,538160,334699,309608,782671,598939,554678,955753,506754,720420,444889,684341,328142,1046219,339514,122809,236955,987719,728538,463398,34621,1015321,710212,911540,214455,905329,1039496,761442,540375,190107,630398,753138,160978,938449,390863,508942,245112,463966,413711,681122,356914,291609,190466,827426,230615,691573,1019068,738657,381209,371521,84092,137454,225648,225971,364635,402294,546134,1027810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003293s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000831s ]