SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330651 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330651 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358576,95110,169697,1026097,266580,633042,831811,132064,106234,900552,648417,22940,824139,919370,421182,86490,357586,140220,318985,1006437,412552,160442,377791,45054,472548,147600,674617,327564,687845,261390,223156,950866,284348,445605,705125,468983,217287,485596,479143,4486,439105,526210,268874,229658,150538,1024931,22839,232742,609029,414673,897249,431438,538814,207051,275901,562880,698846,881949,198659,397389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001315s ]