SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48383 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48383 [ RunTime:0.001663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185900,30364,970745,820177,177761,656913,956860,941797,471392,509744,471708,277529,710525,320889,979029,522546,1042332,847253,212254,404241,624306,337600,673434,727012,831470,492053,469719,292110,620510,966102,859189,425165,475983,670875,172026,407474,32658,914443,1043309,294466,384084,25032,50254,202823,240381,569578,835876,492800,748764,353295,27578,119810,1013108,223869,169224,1039901,441649,1044512,315270,253701) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]