SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406125 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406125 [ RunTime:0.002787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722061,358284,649364,657294,128593,344427,326595,483693,831038,150438,211158,52573,985372,20771,879807,721948,454085,544220,887031,714540,415191,147743,62435,105660,285284,820670,672054,661486,255370,1010380,574015,826635,153732,545327,596001,592343,729078,944346,190251,70803,192593,841555,855913,966058,954124,4814,1015039,449207,792294,724880,668296,635777,1030296,822326,894117,212660,185417,238659,334990,199771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406125 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406125 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]