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` = 195660 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195660 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444429,190596,604983,852109,852629,649556,283502,950006,662626,502918,892736,824684,412480,696238,791852,219276,999271,315897,442343,106809,834436,650178,1027136,762491,724469,701821,711676,847024,945218,19901,367365,885693,533152,560005,949413,513708,187601,362874,188065,452188,48652,969726,502552,1040258,81641,499383,259437,872685,296714,974453,390603,671836,565743,973177,977940,132323,408488,194687,509979,217830) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195660 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195660 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]