SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456141 LIMIT 1 [ RunTime:0.001240s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456141 [ RunTime:0.002702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (686839,269019,248634,371897,14142,418617,12970,223687,454274,118209,310504,473639,190217,747605,949314,580128,270315,507911,789908,555163,223609,108981,405549,184112,566543,40449,85771,713902,1024922,908106,69573,44981,301636,628011,821065,582898,334469,23927,347685,732851,224544,699909,740573,931168,618037,807537,1045270,209810,221301,849979,35664,258449,799440,168003,868283,72976,958303,863749,358732,477733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]