SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017978 LIMIT 1 [ RunTime:0.000621s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017978 [ RunTime:0.001788s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235291,427248,914818,429507,378022,925218,776102,393224,89586,372300,1035666,217825,849252,277505,510393,1015677,266354,376480,122184,67417,75474,888254,402601,835367,713621,92210,401926,8223,250138,450227,496372,658713,436873,723478,340210,993656,241397,112553,954661,821859,637911,192123,206980,542932,531344,108112,450622,851432,722825,787178,55832,641817,756783,928940,480676,1038276,878225,462270,1044293,487703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001271s ]