SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554473 LIMIT 1 [ RunTime:0.001186s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554473 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735947,452312,756304,663170,779456,491715,760251,898000,791719,372074,42476,472111,291088,49602,100317,390983,316607,1004839,821499,593143,870741,813557,106846,161884,1335,512248,201383,952354,297482,161856,883790,866938,395810,597226,763272,527777,146440,19201,250904,8512,945416,523270,675531,510175,1038729,788017,439127,676050,683982,282543,276061,984996,323223,603439,404936,636134,660199,17213,357513,607035) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001962s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554473 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554473 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]