SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001409s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407712 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407712 [ RunTime:0.001965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045998,886561,277317,346787,50854,998733,493396,262785,225538,555952,58086,392932,553576,591488,19769,194484,90942,980899,104861,783863,452691,682869,755607,193342,934470,14877,641593,1040312,709125,146409,500667,708317,531984,743547,658899,710335,1016503,848089,70437,660247,1038829,180728,641715,758015,630452,806782,494663,886778,839689,554267,701528,574921,341530,30559,707838,258372,304086,440582,910393,112866) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]