SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681990 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681990 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (373445,527768,1014014,636754,671225,286183,385512,141731,833019,981112,883256,114823,562480,863513,859452,519804,724620,733116,868793,708159,585778,76338,606185,533171,196018,678042,327897,86907,475595,718747,1048366,72991,516596,721994,502501,1025047,560220,327221,534792,147184,604658,102987,759815,683166,949317,140077,650376,211328,616273,1017584,54695,111150,754659,522556,979215,976329,1041136,357710,481300,14686) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]