SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50126 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50126 [ RunTime:0.002805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221910,585167,368576,543115,309818,1007599,769330,584808,706783,274496,295912,626322,575628,992097,233269,916142,1022802,225507,345716,280595,749139,706946,971731,617441,211150,372276,879968,88425,580738,45671,562515,838479,527684,258390,215275,1030547,260187,100756,676351,341584,50234,416820,404595,562638,318533,1017,852243,520979,925991,185039,818231,235431,730792,684594,231748,143544,293739,482721,131420,809735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001808s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001105s ]