SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591810 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591810 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (429536,586274,552784,954445,995805,106316,805895,96329,968573,179281,925251,946330,586715,1029209,850185,410480,578309,747963,976394,908735,238130,215125,980804,406159,559324,700083,527002,572272,314965,248250,684758,795840,512137,815043,362930,903508,299275,642438,494615,220628,608999,704533,768733,380711,1024673,380183,397043,237857,353516,994920,1032901,471610,375455,995881,8288,672771,381548,546121,250278,375311) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001325s ]