SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001489s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 359731 LIMIT 1 [ RunTime:0.000503s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 359731 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294308,374754,526860,254872,910106,394334,186971,1033956,741799,782505,109263,348136,463519,227121,649210,56274,687442,943401,524035,721988,206244,1014026,931087,627668,604124,720757,44209,281659,780111,309932,793571,926905,756897,33959,520860,1034067,182816,365695,518126,578377,61104,293295,452124,503431,259781,1029606,226799,520510,358472,486017,632851,643573,746695,921345,372102,201761,905777,15128,721769,1947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 359731 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 359731 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000897s ]