SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001698s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505426 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505426 [ RunTime:0.002704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (695251,761065,647582,46062,222527,628827,802031,619820,783383,747076,45457,863993,611973,542024,518748,735586,1022889,757250,443901,343961,559640,688956,531170,296773,603265,460658,811007,404730,717383,421401,629608,20825,197829,304916,105211,668130,307790,189376,245168,627638,876729,477493,963030,834849,747886,770258,508644,806683,589359,501791,437311,302976,748386,809877,684157,399414,307512,906162,320028,819546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505426 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505426 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]