SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419388 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419388 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200221,488012,705143,585361,447949,74703,493481,444176,725802,967509,144176,511044,342820,773436,718852,123400,385608,830117,640748,632075,806501,56146,587424,763148,144850,737360,7066,308145,735532,787047,656752,724437,19812,591466,827385,89951,430627,780680,400302,257505,499870,97599,883160,434334,17518,76414,358062,450826,922900,212669,450525,412413,238190,851590,1025286,1031945,89717,323251,405957,860338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419388 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419388 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]