SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040050 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040050 [ RunTime:0.001637s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835409,581830,33599,394279,808908,395468,940195,288811,745937,415709,1000320,868183,914103,938625,200312,720802,305016,518760,916325,296719,156631,951876,488316,584733,239627,649146,344257,801494,464359,28585,611593,703979,691428,816549,273635,317251,452220,215851,876566,361242,1030638,385732,573246,418119,910677,573651,657304,84247,341845,994411,670148,184797,797018,198113,458071,614299,380552,457186,312645,826618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040050 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040050 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]