SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019118 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019118 [ RunTime:0.003117s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582719,923128,704920,119557,619366,402683,343269,82781,26446,868629,331665,397581,683156,808942,1041573,987199,178728,989844,435205,815583,201456,573057,813150,506522,474546,467442,769965,525815,318421,651747,489832,213837,781763,338580,12466,412367,144714,972465,749766,319697,124327,848732,674826,40835,378854,646635,356928,547248,145066,299659,384513,208029,865359,128155,380292,624241,81678,605472,959614,1010920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]