SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413781 LIMIT 1 [ RunTime:0.003550s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413781 [ RunTime:0.001989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36299,906461,867228,900279,48569,238395,857871,824877,573643,465226,253598,964397,61015,147027,922656,817373,749951,747369,125492,619874,314432,631963,52830,860747,1387,800644,443688,570502,606895,890491,524640,151470,47253,822441,1048883,206980,203698,12969,899162,854131,1024123,29877,1041733,56832,1006359,218261,753546,236540,749379,582655,771261,1019909,971941,117716,989289,609435,802941,1014391,867101,324227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002806s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000821s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000737s ]